ADD JAR hdfs:///hive_udf/ojdbc8-19.3.0.0.jar;

CREATE TEMPORARY VIEW dm_netmng_month_order_sign_summary_dt_tmp
USING org.apache.spark.sql.jdbc
OPTIONS (
url "jdbc:oracle:thin:@//pro-bigdatareport-2023-readwrite-ora.yl.com:1521/orcl",
dbtable 'dm_netmng_month_order_sign_summary_dt',
driver 'oracle.jdbc.driver.OracleDriver',
user 'jms_bigdata_report',
password 'H15DCte03YPW3B2pEA',
isolationLevel 'NONE',
batchsize 1000,
truncate true
);


INSERT overwrite TABLE dm_netmng_month_order_sign_summary_dt_tmp
select month_first_day
      ,mon_num
      ,mon_sign_num
      ,date_time
      ,from_unixtime(unix_timestamp(), 'yyyy-MM-dd HH:mm:ss') as update_time
from jms_dm.dm_netmng_month_order_sign_summary_dt
where dt = '{{ execution_date | cst_ds }}'
;
